/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 80022
 Source Host           : localhost:3306
 Source Schema         : shop_0307

 Target Server Type    : MySQL
 Target Server Version : 80022
 File Encoding         : 65001

 Date: 09/03/2022 23:00:25
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '字典ID',
  `dict_name` varchar(255) DEFAULT NULL COMMENT '字典名称',
  `dict_code` varchar(255) DEFAULT NULL COMMENT '字典代码',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` VALUES (1, '商品分类', 'DM_SPFL', '2022-03-08 13:09:04', '2022-03-08 13:09:07');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_item
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_item`;
CREATE TABLE `sys_dict_item` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '字典项主键',
  `pid` int DEFAULT NULL COMMENT '字典父项ID',
  `dict_code` varchar(255) NOT NULL DEFAULT '' COMMENT '字典外键',
  `item_name` varchar(255) DEFAULT NULL COMMENT '字典项名',
  `item_desc` varchar(255) DEFAULT NULL COMMENT '字典项描述',
  `item_icon` varchar(255) DEFAULT NULL COMMENT '字典项图标',
  `state` int NOT NULL DEFAULT '1' COMMENT '状态 0:禁用 1:启用',
  `rank` int NOT NULL DEFAULT '1' COMMENT '排序 越大越靠前',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1005 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_dict_item
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_item` VALUES (759, NULL, 'DM_SPFL', '家用电器', NULL, '/images/cake.png', 1, 1, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (760, 759, 'DM_SPFL', '生活电器', NULL, NULL, 1, 1, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (761, 760, 'DM_SPFL', '取暖电器', NULL, NULL, 1, 1, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (762, 760, 'DM_SPFL', '吸尘器', NULL, NULL, 1, 2, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (763, 760, 'DM_SPFL', '净化器', NULL, NULL, 1, 3, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (764, 760, 'DM_SPFL', '扫地机器人', NULL, NULL, 1, 4, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (765, 760, 'DM_SPFL', '加湿器', NULL, NULL, 1, 5, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (766, 760, 'DM_SPFL', '熨斗', NULL, NULL, 1, 6, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (767, 760, 'DM_SPFL', '电风扇', NULL, NULL, 1, 7, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (768, 760, 'DM_SPFL', '冷风扇', NULL, NULL, 1, 8, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (769, 760, 'DM_SPFL', '插座', NULL, NULL, 1, 9, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (770, 759, 'DM_SPFL', '厨房小电', NULL, NULL, 1, 2, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (771, 770, 'DM_SPFL', '电饭煲', NULL, NULL, 1, 1, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (772, 770, 'DM_SPFL', '微波炉', NULL, NULL, 1, 2, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (773, 770, 'DM_SPFL', '电烤箱', NULL, NULL, 1, 3, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (774, 770, 'DM_SPFL', '电磁炉', NULL, NULL, 1, 4, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (775, 770, 'DM_SPFL', '电压力锅', NULL, NULL, 1, 5, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (776, 770, 'DM_SPFL', '豆浆机', NULL, NULL, 1, 6, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (777, 770, 'DM_SPFL', '咖啡机', NULL, NULL, 1, 7, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (778, 770, 'DM_SPFL', '面包机', NULL, NULL, 1, 8, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (779, 770, 'DM_SPFL', '榨汁机', NULL, NULL, 1, 9, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (780, 759, 'DM_SPFL', '实力商家', NULL, NULL, 1, 3, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (781, 780, 'DM_SPFL', '海尔', NULL, NULL, 1, 1, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (782, 780, 'DM_SPFL', '三星', NULL, NULL, 1, 2, '2022-03-08 15:28:10', '2022-03-08 15:28:10');
INSERT INTO `sys_dict_item` VALUES (783, 780, 'DM_SPFL', '飞利浦', NULL, NULL, 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (784, 780, 'DM_SPFL', '九阳', NULL, NULL, 1, 4, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (785, 780, 'DM_SPFL', '海信', NULL, NULL, 1, 5, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (786, NULL, 'DM_SPFL', '手机/数码', NULL, '/images/cookies.png', 1, 2, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (787, 786, 'DM_SPFL', '手机', NULL, NULL, 1, 1, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (788, 787, 'DM_SPFL', '手机', NULL, NULL, 1, 1, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (789, 787, 'DM_SPFL', '对讲机', NULL, NULL, 1, 2, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (790, 787, 'DM_SPFL', '以旧换新', NULL, NULL, 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (791, 787, 'DM_SPFL', '手机维修', NULL, NULL, 1, 4, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (792, 786, 'DM_SPFL', '数码配件', NULL, NULL, 1, 2, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (793, 792, 'DM_SPFL', '存储卡', NULL, NULL, 1, 1, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (794, 792, 'DM_SPFL', '三脚架/云台', NULL, NULL, 1, 2, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (795, 792, 'DM_SPFL', '相机包', NULL, NULL, 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (796, 792, 'DM_SPFL', '滤镜', NULL, NULL, 1, 4, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (797, 792, 'DM_SPFL', '闪光灯', NULL, NULL, 1, 5, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (798, 792, 'DM_SPFL', '相机清洗', NULL, NULL, 1, 6, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (799, 792, 'DM_SPFL', '机身附件', NULL, NULL, 1, 7, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (800, 792, 'DM_SPFL', '镜头附件', NULL, NULL, 1, 8, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (801, 792, 'DM_SPFL', '读卡器', NULL, NULL, 1, 9, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (802, 786, 'DM_SPFL', '智能设备', NULL, NULL, 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (803, 802, 'DM_SPFL', '智能手环', NULL, NULL, 1, 1, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (804, 802, 'DM_SPFL', '智能手表', NULL, NULL, 1, 2, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (805, 802, 'DM_SPFL', '智能眼镜', NULL, NULL, 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (806, 802, 'DM_SPFL', '智能机器人', NULL, NULL, 1, 4, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (807, 802, 'DM_SPFL', '运动跟踪器', NULL, NULL, 1, 5, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (808, 802, 'DM_SPFL', '智能家居', NULL, NULL, 1, 6, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (809, 802, 'DM_SPFL', '体感机', NULL, NULL, 1, 7, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (810, 802, 'DM_SPFL', '无人机', NULL, NULL, 1, 8, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (811, 802, 'DM_SPFL', '其他配件', NULL, NULL, 1, 9, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (812, 786, 'DM_SPFL', '实力商家', NULL, NULL, 1, 4, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (813, 812, 'DM_SPFL', '小米', NULL, NULL, 1, 1, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (814, 812, 'DM_SPFL', 'SONY', NULL, NULL, 1, 2, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (815, 812, 'DM_SPFL', 'Nikon', NULL, NULL, 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (816, 812, 'DM_SPFL', '华为', NULL, NULL, 1, 4, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (817, 812, 'DM_SPFL', '魅族手机', NULL, NULL, 1, 5, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (818, 812, 'DM_SPFL', '三星', NULL, NULL, 1, 6, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (819, NULL, 'DM_SPFL', '家居/家具', NULL, '/images/meat.png', 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (820, 819, 'DM_SPFL', '家具', NULL, NULL, 1, 1, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (821, 820, 'DM_SPFL', '卧室家具', NULL, NULL, 1, 1, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (822, 820, 'DM_SPFL', '客厅家具', NULL, NULL, 1, 2, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (823, 820, 'DM_SPFL', '餐厅家具', NULL, NULL, 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (824, 820, 'DM_SPFL', '书房家具', NULL, NULL, 1, 4, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (825, 820, 'DM_SPFL', '儿童家具', NULL, NULL, 1, 5, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (826, 819, 'DM_SPFL', '灯具', NULL, NULL, 1, 2, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (827, 826, 'DM_SPFL', '台灯', NULL, NULL, 1, 1, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (828, 826, 'DM_SPFL', '吸顶灯', NULL, NULL, 1, 2, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (829, 826, 'DM_SPFL', 'LED灯', NULL, NULL, 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (830, 826, 'DM_SPFL', '节能灯', NULL, NULL, 1, 4, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (831, 826, 'DM_SPFL', '落地灯', NULL, NULL, 1, 5, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (832, 819, 'DM_SPFL', '厨具', NULL, NULL, 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (833, 832, 'DM_SPFL', '烹饪厨具', NULL, NULL, 1, 1, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (834, 832, 'DM_SPFL', '刀剪菜饭', NULL, NULL, 1, 2, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (835, 832, 'DM_SPFL', '水具酒具', NULL, NULL, 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (836, 832, 'DM_SPFL', '茶具', NULL, NULL, 1, 4, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (837, 832, 'DM_SPFL', '咖啡具', NULL, NULL, 1, 5, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (838, 819, 'DM_SPFL', '实力商家', NULL, NULL, 1, 4, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (839, 838, 'DM_SPFL', '花颜巧语', NULL, NULL, 1, 1, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (840, 838, 'DM_SPFL', '糖衣小屋', NULL, NULL, 1, 2, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (841, 838, 'DM_SPFL', '卡拉迪克', NULL, NULL, 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (842, 838, 'DM_SPFL', '暖春童话', NULL, NULL, 1, 4, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (843, 838, 'DM_SPFL', '华盛童装批发行', NULL, NULL, 1, 5, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (844, 838, 'DM_SPFL', '奈仕华童装旗舰店', NULL, NULL, 1, 6, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (845, 838, 'DM_SPFL', '斑蒂尼BONDYNI', NULL, NULL, 1, 7, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (846, 838, 'DM_SPFL', '猫儿朵朵', NULL, NULL, 1, 8, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (847, 838, 'DM_SPFL', '童衣阁', NULL, NULL, 1, 9, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (848, NULL, 'DM_SPFL', '素食/卤味', NULL, '/images/bamboo.png', 1, 4, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (849, 848, 'DM_SPFL', '素食', NULL, NULL, 1, 1, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (850, 849, 'DM_SPFL', '蒸蛋糕', NULL, NULL, 1, 1, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (851, 849, 'DM_SPFL', '脱水蛋糕', NULL, NULL, 1, 2, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (852, 849, 'DM_SPFL', '瑞士卷', NULL, NULL, 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (853, 849, 'DM_SPFL', '铜锣烧', NULL, NULL, 1, 4, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (854, 849, 'DM_SPFL', '软面包', NULL, NULL, 1, 5, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (855, 849, 'DM_SPFL', '马卡龙', NULL, NULL, 1, 6, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (856, 849, 'DM_SPFL', '千层饼', NULL, NULL, 1, 7, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (857, 849, 'DM_SPFL', '甜甜圈', NULL, NULL, 1, 8, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (858, 849, 'DM_SPFL', '蒸三明治', NULL, NULL, 1, 9, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (859, 848, 'DM_SPFL', '卤味', NULL, NULL, 1, 2, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (860, 859, 'DM_SPFL', '干笋', NULL, NULL, 1, 1, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (861, 859, 'DM_SPFL', '鸭脖', NULL, NULL, 1, 2, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (862, 859, 'DM_SPFL', '猪手', NULL, NULL, 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (863, 859, 'DM_SPFL', '鸭头', NULL, NULL, 1, 4, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (864, 859, 'DM_SPFL', '猪耳朵', NULL, NULL, 1, 5, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (865, 848, 'DM_SPFL', '实力商家', NULL, NULL, 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (866, 865, 'DM_SPFL', '达利食品', NULL, NULL, 1, 1, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (867, 865, 'DM_SPFL', '米琪', NULL, NULL, 1, 2, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (868, 865, 'DM_SPFL', '迪莉娅', NULL, NULL, 1, 3, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (869, 865, 'DM_SPFL', '艾菲克', NULL, NULL, 1, 4, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (870, 865, 'DM_SPFL', '老昌', NULL, NULL, 1, 5, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (871, 865, 'DM_SPFL', '阿满', NULL, NULL, 1, 6, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (872, NULL, 'DM_SPFL', '坚果/炒货', NULL, '/images/nut.png', 1, 5, '2022-03-08 15:28:11', '2022-03-08 15:28:11');
INSERT INTO `sys_dict_item` VALUES (873, 872, 'DM_SPFL', '坚果', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (874, 873, 'DM_SPFL', '核桃', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (875, 873, 'DM_SPFL', '杏仁', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (876, 873, 'DM_SPFL', '开心果', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (877, 873, 'DM_SPFL', '榛子', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (878, 873, 'DM_SPFL', '松子', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (879, 873, 'DM_SPFL', '腰果', NULL, NULL, 1, 6, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (880, 872, 'DM_SPFL', '炒货', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (881, 880, 'DM_SPFL', '锅巴', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (882, 880, 'DM_SPFL', '花生', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (883, 880, 'DM_SPFL', '瓜子', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (884, 880, 'DM_SPFL', '栗子', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (885, 880, 'DM_SPFL', '玉米', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (886, 872, 'DM_SPFL', '实力商家', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (887, 886, 'DM_SPFL', '老奶奶', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (888, 886, 'DM_SPFL', '恰恰', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (889, 886, 'DM_SPFL', '酒鬼', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (890, 886, 'DM_SPFL', '真心', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (891, 886, 'DM_SPFL', '温州城五区', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (892, NULL, 'DM_SPFL', '糖果/蜜饯', NULL, '/images/candy.png', 1, 6, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (893, 892, 'DM_SPFL', '糖果', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (894, 893, 'DM_SPFL', '花生糖', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (895, 893, 'DM_SPFL', '软糖', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (896, 893, 'DM_SPFL', '奶糖', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (897, 893, 'DM_SPFL', '水果糖', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (898, 893, 'DM_SPFL', '酥糖', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (899, 893, 'DM_SPFL', '牛轧糖', NULL, NULL, 1, 6, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (900, 892, 'DM_SPFL', '蜜饯', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (901, 900, 'DM_SPFL', '葡萄干', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (902, 900, 'DM_SPFL', '地瓜干', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (903, 900, 'DM_SPFL', '蜜枣', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (904, 900, 'DM_SPFL', '无花果', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (905, 900, 'DM_SPFL', '柿子饼', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (906, 900, 'DM_SPFL', '猕猴桃干', NULL, NULL, 1, 6, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (907, 900, 'DM_SPFL', '糖樱桃', NULL, NULL, 1, 7, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (908, 892, 'DM_SPFL', '实力商家', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (909, 908, 'DM_SPFL', '不老林', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (910, 908, 'DM_SPFL', '徐福记', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (911, 908, 'DM_SPFL', '马大姐', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (912, 908, 'DM_SPFL', '金丝猴', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (913, 908, 'DM_SPFL', '小白兔', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (914, NULL, 'DM_SPFL', '巧克力', NULL, '/images/chocolate.png', 1, 7, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (915, 914, 'DM_SPFL', '巧克力', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (916, 915, 'DM_SPFL', '德芙', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (917, 915, 'DM_SPFL', '费列罗', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (918, 915, 'DM_SPFL', '金帝', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (919, 915, 'DM_SPFL', '好时', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (920, 915, 'DM_SPFL', '金莎', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (921, 915, 'DM_SPFL', '明治', NULL, NULL, 1, 6, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (922, 914, 'DM_SPFL', '果冻', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (923, 922, 'DM_SPFL', '喜之郎', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (924, 922, 'DM_SPFL', '蜡笔小新', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (925, 922, 'DM_SPFL', '亲亲果冻', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (926, 922, 'DM_SPFL', '金娃果冻', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (927, 922, 'DM_SPFL', '徐福记', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (928, 922, 'DM_SPFL', '旺旺食品', NULL, NULL, 1, 6, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (929, 922, 'DM_SPFL', '金丝猴', NULL, NULL, 1, 7, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (930, 914, 'DM_SPFL', '实力商家', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (931, 930, 'DM_SPFL', '妙久食品', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (932, 930, 'DM_SPFL', '达达食品', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (933, 930, 'DM_SPFL', '果真小店', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (934, 930, 'DM_SPFL', '锦食阁小店', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (935, NULL, 'DM_SPFL', '海鲜/肉类', NULL, '/images/fish.png', 1, 8, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (936, 935, 'DM_SPFL', '海鲜', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (937, 936, 'DM_SPFL', '鱼类', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (938, 936, 'DM_SPFL', '虾类', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (939, 936, 'DM_SPFL', '蟹类', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (940, 936, 'DM_SPFL', '贝类', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (941, 936, 'DM_SPFL', '海参', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (942, 936, 'DM_SPFL', '三文鱼', NULL, NULL, 1, 6, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (943, 936, 'DM_SPFL', '海鲜加工品', NULL, NULL, 1, 7, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (944, 935, 'DM_SPFL', '肉类', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (945, 944, 'DM_SPFL', '猪肉', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (946, 944, 'DM_SPFL', '牛肉', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (947, 944, 'DM_SPFL', '羊肉', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (948, 944, 'DM_SPFL', '鸡肉', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (949, 944, 'DM_SPFL', '鸭肉', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (950, 944, 'DM_SPFL', '冷鲜肉', NULL, NULL, 1, 6, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (951, 944, 'DM_SPFL', '特色肉类', NULL, NULL, 1, 7, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (952, 935, 'DM_SPFL', '实力商家', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (953, 952, 'DM_SPFL', '双汇', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (954, 952, 'DM_SPFL', '华正', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (955, 952, 'DM_SPFL', '高金', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (956, 952, 'DM_SPFL', '皓月', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (957, 952, 'DM_SPFL', '海天下', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (958, 952, 'DM_SPFL', '美佳佳', NULL, NULL, 1, 6, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (959, NULL, 'DM_SPFL', '花茶/名酒', NULL, '/images/tea.png', 1, 9, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (960, 959, 'DM_SPFL', '花茶', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (961, 960, 'DM_SPFL', '铁观音', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (962, 960, 'DM_SPFL', '普洱', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (963, 960, 'DM_SPFL', '绿茶', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (964, 960, 'DM_SPFL', '红茶', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (965, 960, 'DM_SPFL', '龙井', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (966, 960, 'DM_SPFL', '乌龙茶', NULL, NULL, 1, 6, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (967, 960, 'DM_SPFL', '茉莉花茶', NULL, NULL, 1, 7, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (968, 959, 'DM_SPFL', '名酒', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (969, 968, 'DM_SPFL', '白酒', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (970, 968, 'DM_SPFL', '葡萄酒', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (971, 968, 'DM_SPFL', '洋酒', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (972, 968, 'DM_SPFL', '啤酒', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (973, 968, 'DM_SPFL', '黄酒', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (974, 968, 'DM_SPFL', '养生酒', NULL, NULL, 1, 6, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (975, 968, 'DM_SPFL', '陈年老酒', NULL, NULL, 1, 7, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (976, 959, 'DM_SPFL', '实力商家', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (977, 976, 'DM_SPFL', '茅台', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (978, 976, 'DM_SPFL', '劲牌', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (979, 976, 'DM_SPFL', '泸州老窖', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (980, 976, 'DM_SPFL', '竹叶青', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (981, 976, 'DM_SPFL', '西凤', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (982, 976, 'DM_SPFL', '蓝色经典', NULL, NULL, 1, 6, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (983, NULL, 'DM_SPFL', '箱包', NULL, '/images/package.png', 1, 10, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (984, 983, 'DM_SPFL', '精品男包', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (985, 984, 'DM_SPFL', '男士钱包', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (986, 984, 'DM_SPFL', '男士手包', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (987, 984, 'DM_SPFL', '双肩包', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (988, 984, 'DM_SPFL', '公文包', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (989, 984, 'DM_SPFL', '男士腰带', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (990, 984, 'DM_SPFL', '单肩斜挎', NULL, NULL, 1, 6, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (991, 983, 'DM_SPFL', '旅行箱包', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (992, 991, 'DM_SPFL', '拉杆箱包', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (993, 991, 'DM_SPFL', '电脑包', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (994, 991, 'DM_SPFL', '书包', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (995, 991, 'DM_SPFL', '休闲运动', NULL, NULL, 1, 4, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (996, 991, 'DM_SPFL', '旅行包', NULL, NULL, 1, 5, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (997, 991, 'DM_SPFL', '旅行配件', NULL, NULL, 1, 6, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (998, 983, 'DM_SPFL', '实力商家', NULL, NULL, 1, 3, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (999, 998, 'DM_SPFL', '美屡自营', NULL, NULL, 1, 1, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (1000, 998, 'DM_SPFL', '安德里自营', NULL, NULL, 1, 2, '2022-03-08 15:28:12', '2022-03-08 15:28:12');
INSERT INTO `sys_dict_item` VALUES (1001, 998, 'DM_SPFL', '巴特利专卖', NULL, NULL, 1, 3, '2022-03-08 15:28:13', '2022-03-08 15:28:13');
INSERT INTO `sys_dict_item` VALUES (1002, 998, 'DM_SPFL', '皮尔卡丹', NULL, NULL, 1, 4, '2022-03-08 15:28:13', '2022-03-08 15:28:13');
INSERT INTO `sys_dict_item` VALUES (1003, 998, 'DM_SPFL', '老人头', NULL, NULL, 1, 5, '2022-03-08 15:28:13', '2022-03-08 15:28:13');
INSERT INTO `sys_dict_item` VALUES (1004, 998, 'DM_SPFL', '金利来', NULL, NULL, 1, 6, '2022-03-08 15:28:13', '2022-03-08 15:28:13');
COMMIT;

-- ----------------------------
-- Table structure for t_cart
-- ----------------------------
DROP TABLE IF EXISTS `t_cart`;
CREATE TABLE `t_cart` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '购物车商品主键',
  `user_id` int NOT NULL COMMENT '用户外键',
  `goods_id` int NOT NULL COMMENT '商品主键',
  `goods_num` int NOT NULL DEFAULT '1' COMMENT '数量',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_cart
-- ----------------------------
BEGIN;
INSERT INTO `t_cart` VALUES (9, 1, 1, 1, '2022-03-09 19:11:20', '2022-03-09 19:11:20');
INSERT INTO `t_cart` VALUES (10, 7, 4, 1, '2022-03-09 21:57:47', '2022-03-09 21:57:47');
COMMIT;

-- ----------------------------
-- Table structure for t_goods
-- ----------------------------
DROP TABLE IF EXISTS `t_goods`;
CREATE TABLE `t_goods` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '商品主键',
  `user_id` int NOT NULL COMMENT '用户外键',
  `type_id` int NOT NULL COMMENT '分类外键',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '商品名',
  `price` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '商品价格',
  `photo` varchar(255) NOT NULL DEFAULT '' COMMENT '商品图片',
  `num` int NOT NULL DEFAULT '0' COMMENT '供应量',
  `descript` varchar(255) NOT NULL DEFAULT '' COMMENT '商品描述',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_goods
-- ----------------------------
BEGIN;
INSERT INTO `t_goods` VALUES (4, 7, 761, '华为HUAWEI显示器S24 23.8英寸 IPS三微边全面屏 75Hz 低蓝光无频闪双重护眼 可壁挂 快拆底座 电脑办公', 899.00, 'http://img10.360buyimg.com/n7/jfs/t1/199737/7/13247/143635/616bb7fdE8327b35b/25d21f35a9960015.jpg', 999, '1) 液晶显示器主机x1 2) 电源适配器x 1 3)HDMIx 1 4)《快速入门指南》x 1 5)保修卡x 1', '2022-03-09 21:21:38', '2022-03-09 21:21:38');
INSERT INTO `t_goods` VALUES (5, 7, 761, '北京旅游5天4晚亲子游丨天安门毛主席纪念堂故宫长城鸟巢+品北京烤鸭+赠送北京曲艺专场演出 A套餐 成人', 2001.00, 'https://img10.360buyimg.com/n7/jfs/t1/189687/26/1739/131756/6094aa47Ef1656867/25374b81ed5b43ff.jpg', 9998, '因厂家会在没有任何提前通知的情况下更改产品包装、产地或者一些附件，本司不能确保客户收到的货物与商城图片、产地、附件说明完全一致。只能确保为原厂正货！并且保证与当时市场上同样主流新品一致。若本商城没有及时更新，请大家谅解！', '2022-03-09 21:54:14', '2022-03-09 21:54:14');
INSERT INTO `t_goods` VALUES (6, 7, 761, '【跟团游】新疆旅游8日游可可托海五彩滩喀纳斯湖胡杨林天池，赠吐鲁番瓜果之乡 新疆8天 成人', 2999.00, 'https://img11.360buyimg.com/n7/jfs/t1/174414/11/8229/187336/6094bdc0Ede5d6442/ea1c57f008c4d0a8.jpg', 16666, '新疆旅游8日游可可托海五彩滩喀纳斯湖胡杨林天池，赠吐鲁番瓜果之乡 新疆8天 成人', '2022-03-09 21:55:53', '2022-03-09 21:55:53');
INSERT INTO `t_goods` VALUES (7, 7, 761, '七彩虹（Colorful）iGame GeForce RTX 3070 Ti Ultra W OC 8G 1770-1800Mhz 赛博朋克2077游戏光追电脑显卡', 5899.00, 'https://img11.360buyimg.com/n7/jfs/t1/194532/40/14445/97532/60fa738dE8ce671d6/a516bc6f007cafdd.jpg', 1233, 'RGB潮客灯，一键超频，白色限定版。七彩虹将星新品12代酷睿游戏本，购机晒单赠好礼，幸运抽显卡。', '2022-03-09 22:03:36', '2022-03-09 22:03:36');
INSERT INTO `t_goods` VALUES (8, 7, 761, '华硕 ASUS DUAL-RX6600XT-O8G AMD RADEON RX 6600 XT 电竞游戏显卡', 3677.00, 'https://img14.360buyimg.com/n7/jfs/t1/197665/12/2433/206238/611218f1E3cc70ca5/80a61785c2efc192.jpg', 1231, 'ROG显卡支架，神光同步，铝合金加固，个性设计', '2022-03-09 22:04:34', '2022-03-09 22:04:34');
COMMIT;

-- ----------------------------
-- Table structure for t_order
-- ----------------------------
DROP TABLE IF EXISTS `t_order`;
CREATE TABLE `t_order` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '订单主键',
  `user_id` int NOT NULL COMMENT '用户外键',
  `state` int NOT NULL DEFAULT '0' COMMENT '订单状态0：待付款 1：已付款 2：已关闭',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_order
-- ----------------------------
BEGIN;
INSERT INTO `t_order` VALUES (1, 1, 0, '2022-03-09 16:10:59', '2022-03-09 16:10:59');
INSERT INTO `t_order` VALUES (2, 1, 0, '2022-03-09 16:14:19', '2022-03-09 16:14:19');
INSERT INTO `t_order` VALUES (3, 1, 0, '2022-03-09 16:15:56', '2022-03-09 16:15:56');
INSERT INTO `t_order` VALUES (4, 1, 0, '2022-03-09 16:17:45', '2022-03-09 16:17:45');
INSERT INTO `t_order` VALUES (5, 1, 0, '2022-03-09 16:17:59', '2022-03-09 16:17:59');
INSERT INTO `t_order` VALUES (6, 1, 0, '2022-03-09 16:18:35', '2022-03-09 16:18:35');
INSERT INTO `t_order` VALUES (7, 1, 0, '2022-03-09 16:20:45', '2022-03-09 16:20:45');
INSERT INTO `t_order` VALUES (8, 1, 0, '2022-03-09 16:21:39', '2022-03-09 16:21:39');
INSERT INTO `t_order` VALUES (9, 1, 0, '2022-03-09 16:22:45', '2022-03-09 16:22:45');
INSERT INTO `t_order` VALUES (10, 1, 0, '2022-03-09 16:59:13', '2022-03-09 16:59:13');
INSERT INTO `t_order` VALUES (11, 1, 0, '2022-03-09 17:04:52', '2022-03-09 17:04:52');
INSERT INTO `t_order` VALUES (12, 1, 0, '2022-03-09 17:05:25', '2022-03-09 17:05:25');
INSERT INTO `t_order` VALUES (13, 1, 0, '2022-03-09 17:05:56', '2022-03-09 17:05:56');
INSERT INTO `t_order` VALUES (14, 1, 0, '2022-03-09 17:11:45', '2022-03-09 17:11:45');
INSERT INTO `t_order` VALUES (15, 1, 0, '2022-03-09 17:26:39', '2022-03-09 17:26:39');
INSERT INTO `t_order` VALUES (16, 1, 0, '2022-03-09 18:54:59', '2022-03-09 18:54:59');
INSERT INTO `t_order` VALUES (17, 1, 0, '2022-03-09 18:55:10', '2022-03-09 18:55:10');
INSERT INTO `t_order` VALUES (18, 1, 0, '2022-03-09 19:03:10', '2022-03-09 19:03:10');
INSERT INTO `t_order` VALUES (19, 1, 0, '2022-03-09 19:03:52', '2022-03-09 19:03:52');
INSERT INTO `t_order` VALUES (20, 1, 0, '2022-03-09 19:06:09', '2022-03-09 19:06:09');
INSERT INTO `t_order` VALUES (27, 1, 0, '2022-03-09 22:54:54', '2022-03-09 22:54:54');
INSERT INTO `t_order` VALUES (28, 1, 0, '2022-03-09 22:59:18', '2022-03-09 22:59:18');
COMMIT;

-- ----------------------------
-- Table structure for t_order_item
-- ----------------------------
DROP TABLE IF EXISTS `t_order_item`;
CREATE TABLE `t_order_item` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '订单项主键',
  `order_id` int NOT NULL COMMENT '订单外键ID',
  `num` int NOT NULL DEFAULT '0' COMMENT '数量',
  `goods_id` int NOT NULL DEFAULT '0' COMMENT '商品ID',
  `goods_name` varchar(255) NOT NULL DEFAULT '0' COMMENT '商品名称',
  `goods_price` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '商品价格',
  `goods_img` varchar(255) NOT NULL DEFAULT '0' COMMENT '商品价格',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_order_item
-- ----------------------------
BEGIN;
INSERT INTO `t_order_item` VALUES (1, 3, 0, 3, '1111', 222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 16:15:56', '2022-03-09 16:15:56');
INSERT INTO `t_order_item` VALUES (2, 4, 0, 3, '1111', 222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 16:17:46', '2022-03-09 16:17:46');
INSERT INTO `t_order_item` VALUES (3, 5, 0, 3, '1111', 222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 16:17:59', '2022-03-09 16:17:59');
INSERT INTO `t_order_item` VALUES (4, 6, 0, 3, '1111', 222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 16:18:35', '2022-03-09 16:18:35');
INSERT INTO `t_order_item` VALUES (5, 7, 0, 3, '1111', 222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 16:20:45', '2022-03-09 16:20:45');
INSERT INTO `t_order_item` VALUES (6, 8, 7, 3, '1111', 222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 16:21:39', '2022-03-09 16:21:39');
INSERT INTO `t_order_item` VALUES (7, 9, 10, 3, '1111', 222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 16:22:45', '2022-03-09 16:22:45');
INSERT INTO `t_order_item` VALUES (8, 10, 7, 3, '1111', 222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 16:59:13', '2022-03-09 16:59:13');
INSERT INTO `t_order_item` VALUES (9, 11, 7, 3, '1111', 222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 17:04:52', '2022-03-09 17:04:52');
INSERT INTO `t_order_item` VALUES (10, 12, 7, 3, '1111', 222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 17:05:25', '2022-03-09 17:05:25');
INSERT INTO `t_order_item` VALUES (11, 13, 7, 3, '1111', 222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 17:05:56', '2022-03-09 17:05:56');
INSERT INTO `t_order_item` VALUES (12, 14, 7, 3, '1111', 222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 17:11:45', '2022-03-09 17:11:45');
INSERT INTO `t_order_item` VALUES (13, 15, 7, 3, '1111', 222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 17:26:39', '2022-03-09 17:26:39');
INSERT INTO `t_order_item` VALUES (14, 16, 2, 2, '1111', 2222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 18:54:59', '2022-03-09 18:54:59');
INSERT INTO `t_order_item` VALUES (15, 17, 1, 1, '1111', 2222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 18:55:10', '2022-03-09 18:55:10');
INSERT INTO `t_order_item` VALUES (16, 18, 1, 1, '1111', 2222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 19:03:10', '2022-03-09 19:03:10');
INSERT INTO `t_order_item` VALUES (17, 19, 1, 1, '1111', 2222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 19:03:52', '2022-03-09 19:03:52');
INSERT INTO `t_order_item` VALUES (18, 20, 1, 1, '1111', 2222.00, 'https://s1.umubiao.com/blog/KQIUxG1IM.jpeg?x-oss-process=image/resize,m_fill,w_800,h_447', '2022-03-09 19:06:09', '2022-03-09 19:06:09');
INSERT INTO `t_order_item` VALUES (25, 27, 1, 4, '华为HUAWEI显示器S24 23.8英寸 IPS三微边全面屏 75Hz 低蓝光无频闪双重护眼 可壁挂 快拆底座 电脑办公', 899.00, 'http://img10.360buyimg.com/n7/jfs/t1/199737/7/13247/143635/616bb7fdE8327b35b/25d21f35a9960015.jpg', '2022-03-09 22:54:54', '2022-03-09 22:54:54');
INSERT INTO `t_order_item` VALUES (26, 28, 1, 5, '北京旅游5天4晚亲子游丨天安门毛主席纪念堂故宫长城鸟巢+品北京烤鸭+赠送北京曲艺专场演出 A套餐 成人', 2001.00, 'https://img10.360buyimg.com/n7/jfs/t1/189687/26/1739/131756/6094aa47Ef1656867/25374b81ed5b43ff.jpg', '2022-03-09 22:59:18', '2022-03-09 22:59:18');
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '用户表主键',
  `nickname` varchar(255) NOT NULL DEFAULT '' COMMENT '用户名',
  `email` varchar(255) NOT NULL DEFAULT '' COMMENT '邮箱',
  `password` varchar(255) NOT NULL DEFAULT '' COMMENT '密码',
  `balance` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `role` int NOT NULL DEFAULT '0' COMMENT '角色0：用户 1：商家',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES (1, 'liupan', '112@qq.com', '96e79218965eb72c92a549dd5a330112', 3606.00, 0, '2022-03-08 00:58:54', '2022-03-08 00:58:54');
INSERT INTO `t_user` VALUES (7, 'liupan', '113@qq.com', '96e79218965eb72c92a549dd5a330112', 0.00, 1, '2022-03-08 02:35:05', '2022-03-08 02:35:05');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
